# Generated manually for performance optimization

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('local_fees', '0006_reset_to_simple_model'),
    ]

    operations = [
        # 为LocalFee表添加性能索引
        migrations.RunSQL(
            "CREATE INDEX IF NOT EXISTS idx_local_fee_pol_pod ON local_fee (polCd, podCd);",
            reverse_sql="DROP INDEX IF EXISTS idx_local_fee_pol_pod;"
        ),
        migrations.RunSQL(
            "CREATE INDEX IF NOT EXISTS idx_local_fee_name ON local_fee (name);",
            reverse_sql="DROP INDEX IF EXISTS idx_local_fee_name;"
        ),
        migrations.RunSQL(
            "CREATE INDEX IF NOT EXISTS idx_local_fee_currency ON local_fee (currency);",
            reverse_sql="DROP INDEX IF EXISTS idx_local_fee_currency;"
        ),
        migrations.RunSQL(
            "CREATE INDEX IF NOT EXISTS idx_local_fee_carriercd ON local_fee (carriercd);",
            reverse_sql="DROP INDEX IF EXISTS idx_local_fee_carriercd;"
        ),
    ]
